mysql常用命令汇总

使用mysqldump:
备份
mysqldump -u databasename -p -h localhost databasename>d:demo.sql
还原
mysql -h localhost -u root -p123456 databasename<d:demo.sql

开启mysql的root用户远程访问权限：
use mysql;

update user set host = '%' where user = 'root';

FLUSH PRIVILEGES;